package com.jz.kufangkuqu.kufang.mapper;

import com.jz.kufangkuqu.kufang.bean.DiQu;
import com.jz.kufangkuqu.kufang.bean.KuFang;
import com.jz.kufangkuqu.kufang.bean.KuFangSelect;
import com.jz.kufangkuqu.kuqu.bean.KuQu;
import com.jz.kufangkuqu.kuwei.bean.KuWei;
import com.jz.kufangkuqu.shuxing.bean.ShuXing;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface KuFangMapper {


    List<KuFang> queryPage(KuFangSelect kuFangSelectVo);

    int count(KuFangSelect kuFangSelectVo);

    List<KuFang> queryBiaoShi();



    void add(KuFang legalPlantVo1);

    int updatePlant(KuFang legalPlant1);

    void updateStatus(KuFang legalPlant1);

    @Select("select * from kufang ")
    List<KuFang> queryKuFangXiaLa();

    @Select("select id,code,name from shuxing")
    List<ShuXing> queryShuXing();

    List<DiQu> queryDiQu(Integer pid);

    @Select(" select  id,code,name from kuqu where wareHouseCode=#{id} ")
    List<KuQu> queryKuQuXiaLa(String id);

    @Select(" select  id,code,name from kuwei  ")
    List<KuWei> queryKuWeiXiaLa(KuWei kuWei);
}
